package com.settlement.system.mapper;

import com.settlement.system.model.entity.common.TblOrderAuditReport;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * 订单稽核报表 Mapper 接口
 *
 * @author Ximi
 * @since 2020-09-22
 */
public interface TblOrderAuditReportMapper extends BaseMapper {

    /**
     * 通过事务号来删除数据
     *
     * @param transactionalNo
     */
    public void deleteByTransactionalNo(@Param("transactionalNo") long transactionalNo);

    /**
     * 批量新增
     *
     * @param auditReportList
     */
    public void batchAdd(@Param("auditReportList") List<TblOrderAuditReport> auditReportList);

    /**
     * 通过店铺账单删除数据
     *
     * @param shopAccount
     */
    public void deleteByShopAccount(@Param("shopAccount") String shopAccount);

    /**
     * 删除通过三级来源
     *
     * @param threeChannelNo
     */
    public void deleteByThreeChannelNo(@Param("threeChannelNo") String threeChannelNo);

    /**
     * 获取合计
     *
     * @param params
     * @return
     */
    public TblOrderAuditReport getFoot(@Param("params") Map<String, Object> params);

    /**
     * 通过优购单号 获取 原始外部订单号
     *
     * @param refBillNo
     * @return
     */
    public String getSpOrderNo(String[] refBillNo);
}

